Selecting N Records From Every Distinct Value Of X Using The Greater Value Of A Sort Column

Use this option to filter records which have a greater value.

1. On N per X, select the relevant option. For this example, One per Household ID from the Customer table.
2. In the Using field select the option. For this example, Income.
3. Select Greater Values.

If the Allow 0s and NULLS to be selected check box is selected, customers with a zero or Null value will be included in the selection.

• N per X
  • Selecting N records from every distinct value of X
  • Selecting N records from every distinct value of X using the greater value of a Sort Column
  • Select lesser values of an N record from every distinct value of X